Re: [GENERAL] Why are my index files are much larger than my datafiles - Mailing list pgsql-general

From Ari Halberstadt
Subject Re: [GENERAL] Why are my index files are much larger than my datafiles
Date
Msg-id v04003a00b34b02b0a82d@[192.168.1.2]
Whole thread Raw
In response to Why are my index files are much larger than my datafiles  (Michael J Davis <michael.j.davis@tvguide.com>)
List pgsql-general
Michael J Davis <michael.j.davis@tvguide.com> wrote:
>...
>The first index is three int4 values.  The second index is one int4 value.
>Why are the index files so large?  What can I do to reclaim the disk space.
>This is after a vacuum.  PostgreSQL 6.5 as of 4/25/99.   Red Hat 5.1 intel
>pentium II.

You could do a drop index followed by a create index followed by a vacuum.

-- Ari Halberstadt mailto:ari@shore.net <http://www.magiccookie.com/>
PGP public key available at <http://www.magiccookie.com/pgpkey.txt>



pgsql-general by date:

Previous
From: Andy Lewis
Date:
Subject: PL/pgSQL
Next
From: Adriaan Joubert
Date:
Subject: Re: [GENERAL] advice on buying sun hardware to run postgres